how to calculate total price in the footer of gridview?

Question

0.00/5 (No votes)

See more:

C#

SQL-Server

SQL-Server-2008

, +

I have this method in the footer of gridview

XML

<asp:TemplateField HeaderText="SALARY">
                  <ItemTemplate>
                  <asp:Label ID="sal1" runat="server" Text='<%# Eval("Total") %>'></asp:Label>
                   </ItemTemplate>
<%--            <asp:BoundField DataField="Total" HeaderText="totalprice" />
--%>            <FooterTemplate>

           <%# gettotal()%>

         </FooterTemplate>
         </asp:TemplateField>

now inside this method I want to calculate the total how to get the values from all cells which in the total column in gridview ??

C#

public int gettotal()
  {

      int totalsal = ;

      return totalsal;

  }

Posted 29-Apr-12 6:17am

Sarah Mohammed77

Add a Solution

Comments

Shahin Khorshidnia 29-Apr-12 12:38pm

Is the GridView bound to a Collection or something else? Is yes why don't you calculate the total from the Collection?

Sarah Mohammed77 29-Apr-12 17:30pm

what did you mean??

Sergey Alexandrovich Kryukov 29-Apr-12 19:45pm

You need to read about binding, to start with...
--SA

2 solutions

Solution 2

Here is Example to total in footer............

C#

protected void grdGuestTotal_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType.Equals(DataControlRowType.Footer))
        {
            //String NetSubTotal = string.Empty;
            // String SubTotal = string.Empty;
            Label NetSubTotal = ((Label)e.Row.FindControl("lblNetSubTotal"));
            Label FinalTotal = ((Label)e.Row.FindControl("lblTotal"));
            NetSubTotal.Text = Total.ToString();
            FinalTotal.Text = EndTotal.ToString();// (Convert.ToDouble(NetSubTotal.Text) + Convert.ToDouble(SubTotal.Text)).ToString();
        }
        if (e.Row.RowType.Equals(DataControlRowType.DataRow))
        {
            //String NetSubTotal = string.Empty;
            // String SubTotal = string.Empty;
            Label SubTotal = ((Label)e.Row.FindControl("lblSubTotal"));
            Label NetTotal = ((Label)e.Row.FindControl("lblNetTotal"));
            double value = Convert.ToDouble(SubTotal.Text);
            Total += value;
            double amount = Convert.ToDouble(NetTotal.Text);

            EndTotal += amount;
        }

    }

[EDIT]CODE tags added - LOSMAC[/EDIT]

Posted 29-Apr-12 8:40am

Chandan Aryan

Updated 29-Apr-12 9:23am

v2

Comments

Sarah Mohammed77 29-Apr-12 17:29pm

thank you so much but i didn't get the total from database it doesn't work for me

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2012-04-29T07:20:00

Solution 1

Have a look at these:
Displaying Total in Footer of GridView[^]
MSDN: GridView Examples for ASP.NET 2.0: Displaying Summary Data in the Footer[^]
CodeSnip: How to Display Sum Total in the Footer of the GridView Control[^]

If needed, look here[^] for more.

Posted 29-Apr-12 7:20am

Sandeep Mewara

Comments

Maciej Los 29-Apr-12 14:10pm

Good links! My 5

Sandeep Mewara 29-Apr-12 14:21pm

Thanks losmac. :)

VJ Reddy 29-Apr-12 21:04pm

Good references. 5!

Sandeep Mewara 30-Apr-12 0:24am

Thanks VJ.